Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, Department, Title, Culture, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Classification
Link | rowid ▼ | Object Number | Is Highlight | Is Public Domain | Object ID | Department | Object Name | Title | Culture | Period | Dynasty | Reign | Portfolio | Artist Role | Artist Prefix | Artist Display Name | Artist Display Bio | Artist Suffix | Artist Alpha Sort | Artist Nationality | Artist Begin Date | Artist End Date | Object Date | Object Begin Date | Object End Date | Medium | Dimensions | Credit Line | Geography Type | City | State | County | Country | Region | Subregion | Locale | Locus | Excavation | River | Classification | Rights and Reproduction | Link Resource | Metadata Date | Repository |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4456 | 4456 | X.225 | 0 | 1 | 4802 | American Decorative Arts 1 | Lock 587 | Lock | American 1 | 1700–1800 | 1700 | 1800 | Iron 13 | 8 1/2 x 6 1/2 in. (21.6 x 16.5 cm) | Museum Accession | Probably made in 2 | United States 3 | Metal 1 | http://www.metmuseum.org/art/collection/search/4802 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||
4475 | 4475 | 35.118 | 0 | 1 | 4821 | American Decorative Arts 1 | Lock 587 | Lock | ca. 1800 | 1797 | 1800 | Iron 13 | 5 7/8 x 10 in. (14.9 x 25.4 cm) | Gift of I. Peace Hazard, 1935 | Metal 1 | http://www.metmuseum.org/art/collection/search/4821 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||||
99338 | 99338 | 83.18.292a–e | 0 | 0 | 186674 | European Sculpture and Decorative Arts 3 | Lock 587 | Lock | British, after Italian original 2087 | 19th century, after 17th century original | 1800 | 1899 | Steel 658 | Gift of Henry G. Marquand, 1883 | Metalwork-Electrotype 136 | http://www.metmuseum.org/art/collection/search/186674 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||||
99930 | 99930 | 91.1.1156 | 0 | 1 | 187278 | European Sculpture and Decorative Arts 3 | Lock 587 | Lock | Italian 36 | 18th century | 1700 | 1799 | Silver 2 | Overall: 2 7/8 × 1 5/8 in. (7.3 × 4.1 cm) | Edward C. Moore Collection, Bequest of Edward C. Moore, 1891 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/187278 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
102224 | 102224 | 07.225.510.1 | 0 | 1 | 189759 | European Sculpture and Decorative Arts 3 | Lock 587 | Lock | French 7 | 18th century | 1700 | 1799 | Gilt bronze 30 | Overall (confirmed): 7 x 8 1/4 x 1 7/8 in., 5.4lb. (17.8 x 21 x 4.8 cm, 2.4494kg) | Gift of J. Pierpont Morgan, 1906 | Metalwork-Gilt Bronze 323 | http://www.metmuseum.org/art/collection/search/189759 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
102269 | 102269 | 07.225.510.49a, b | 0 | 1 | 189804 | European Sculpture and Decorative Arts 3 | Lock 587 | Lock | French 7 | 18th century | 1700 | 1799 | Gilt bronze 30 | 4 × 10 3/4 in. (10.2 × 27.3 cm) | Gift of J. Pierpont Morgan, 1906 | Metalwork-Gilt Bronze 323 | http://www.metmuseum.org/art/collection/search/189804 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
113678 | 113678 | 57.137.6 | 0 | 1 | 201997 | European Sculpture and Decorative Arts 3 | Lock 587 | Lock | German 27 | mid-18th century | 1730 | 1765 | Iron 13 | 8 × 12 3/8 in. (20.3 × 31.4 cm) | Harris Brisbane Dick Fund, 1957 | Metalwork-Steel 329 | http://www.metmuseum.org/art/collection/search/201997 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
113680 | 113680 | 57.137.8a, b | 0 | 1 | 201999 | European Sculpture and Decorative Arts 3 | Lock 587 | Lock | British, Birmingham 398 | Maker 1 | Attributed to | John Wilkes | Wilkes John 10810 | 1600 | 1700 | 17th century | 1600 | 1699 | Steel, brass, wood 3878 | Overall (lock, .8a): 4 7/8 × 5 5/8 × 1 1/2 in. (12.4 × 14.3 × 3.8 cm); Length (key, .8b): 4 11/16 in. (11.9 cm) | Harris Brisbane Dick Fund, 1957 | Metalwork-Brass 17 | http://www.metmuseum.org/art/collection/search/201999 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
113701 | 113701 | 57.137.29a, b | 0 | 1 | 202020 | European Sculpture and Decorative Arts 3 | Lock 587 | Lock | German 27 | 17th century | 1600 | 1699 | Steel, tinned (?) 22663 | Overall: 19 15/16 × 10 7/8 in. (50.6 × 27.6 cm) | Harris Brisbane Dick Fund, 1957 | Metalwork-Steel 329 | http://www.metmuseum.org/art/collection/search/202020 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
324630 | 324630 | 17.190.362 | 0 | 1 | 464342 | Medieval Art 6 | Lock 587 | Lock | French 7 | 15th century | 1400 | 1499 | Iron, copper alloy bells 49226 | Overall (opened): 8 15/16 x 14 7/8 x 1 in. (22.7 x 37.8 x 2.5 cm) Overall (closed): 8 15/16 x 7 3/8 x 2 3/16 in. (22.7 x 18.7 x 5.6 cm) top attachment flange: 3 3/8 x 2 5/8 x 3/8 in. (8.6 x 6.6 x 0.9 cm) | Gift of J. Pierpont Morgan, 1917 | Metalwork-Iron 322 | http://www.metmuseum.org/art/collection/search/464342 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
326599 | 326599 | 25.120.439 | 0 | 1 | 466598 | The Cloisters 17 | Lock 587 | Lock | French 7 | 14th century | 1300 | 1399 | Iron 13 | Overall: 5 x 3 15/16 x 2 5/8 in. (12.7 x 10 x 6.7 cm) | The Cloisters Collection, 1925 | Metalwork-Iron 322 | http://www.metmuseum.org/art/collection/search/466598 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
327231 | 327231 | 32.75.55 | 0 | 1 | 467588 | Medieval Art 6 | Lock 587 | Lock | French 7 | 15th century | 1400 | 1499 | Iron 13 | Overall: 6 x 6 3/8 in. (15.2 x 16.2 cm) | The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932 | Metalwork-Iron 322 | http://www.metmuseum.org/art/collection/search/467588 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
327723 | 327723 | 50.174.1 | 0 | 1 | 468333 | Medieval Art 6 | Lock 587 | Lock | British 6 | 15th century | 1400 | 1499 | Iron 13 | 8 1/4 × 8 1/4 × 4 3/4 in. (21 × 21 × 12 cm) | Gift of Arthur S. Fairchild, 1950 | Metalwork-Iron 322 | http://www.metmuseum.org/art/collection/search/468333 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
327724 | 327724 | 50.174.2a | 0 | 1 | 468334 | Medieval Art 6 | Lock 587 | Lock | Italian 36 | 16th century | 1500 | 1599 | Iron 13 | Overall: 5 11/16 x 6 15/16 x 2 1/2 in. (14.5 x 17.6 x 6.3 cm) | Gift of Arthur S. Fairchild, 1950 | Metalwork-Iron 322 | http://www.metmuseum.org/art/collection/search/468334 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
327880 | 327880 | 55.61.7 | 0 | 1 | 468500 | The Cloisters 17 | Lock 587 | Lock | European 12 | 15th–16th century | 1400 | 1599 | wrought iron 50091 | Overall with strap: 10 3/16 × 14 13/16 × 6 in. (25.9 × 37.7 × 15.3 cm) Overall without strap: 10 3/16 × 14 13/16 × 2 1/16 in. (25.9 × 37.7 × 5.3 cm) | The Cloisters Collection, 1955 | Metalwork-Iron 322 | http://www.metmuseum.org/art/collection/search/468500 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
328165 | 328165 | 87.11.50 | 0 | 1 | 468825 | Medieval Art 6 | Lock 587 | Lock | German 27 | 16th century | 1500 | 1599 | Iron 13 | Overall: 4 11/16 x 4 3/4 x 5/16 in. (11.9 x 12 x 0.8 cm) | Gift of Henry G. Marquand, 1887 | Metalwork-Iron 322 | http://www.metmuseum.org/art/collection/search/468825 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
328205 | 328205 | 87.11.67 | 0 | 1 | 468867 | Medieval Art 6 | Lock 587 | Padlock | French 7 | 16th century | 1500 | 1599 | Iron 13 | Overall: 6 7/16 x 4 15/16 x 4 7/16 in. (16.3 x 12.5 x 11.2 cm) | Gift of Henry G. Marquand, 1887 | Metalwork-Iron 322 | http://www.metmuseum.org/art/collection/search/468867 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
328229 | 328229 | 87.11.706 | 0 | 1 | 468891 | Medieval Art 6 | Lock 587 | Lock | German 27 | 15th–16th century | 1400 | 1599 | Iron 13 | Overall: 10 x 11 3/4 x 3 11/16 in. (25.4 x 29.9 x 9.3 cm) | Gift of Henry G. Marquand, 1887 | Metalwork-Iron 322 | http://www.metmuseum.org/art/collection/search/468891 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
328230 | 328230 | 87.11.707 | 0 | 1 | 468892 | Medieval Art 6 | Lock 587 | Lock | German 27 | early 16th century | 1500 | 1525 | Iron 13 | Overall: 14 9/16 x 16 7/16 x 3 3/8 in. (37 x 41.8 x 8.6 cm) | Gift of Henry G. Marquand, 1887 | Metalwork-Iron 322 | http://www.metmuseum.org/art/collection/search/468892 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
328237 | 328237 | 87.11.716 | 0 | 1 | 468899 | Medieval Art 6 | Lock 587 | Lock | German 27 | 16th century | 1500 | 1599 | Iron 13 | Overall: 12 3/8 x 15 5/16 x 2 in. (31.5 x 38.9 x 5.1 cm) | Gift of Henry G. Marquand, 1887 | Metalwork-Iron 322 | http://www.metmuseum.org/art/collection/search/468899 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
328244 | 328244 | 87.11.8 | 0 | 1 | 468907 | Medieval Art 6 | Lock 587 | Ornamental Lock | German 27 | 15th century | 1400 | 1499 | Iron 13 | Overall: 5 3/16 x 5 5/8 x 1/4 in. (13.2 x 14.3 x 0.6 cm) | Gift of Henry G. Marquand, 1887 | Metalwork-Iron 322 | http://www.metmuseum.org/art/collection/search/468907 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
328622 | 328622 | 55.76.3 | 0 | 1 | 470148 | The Cloisters 17 | Lock 587 | Lock | European or French (?) 6108 | 15th–16th century | 1400 | 1599 | Iron 13 | 8 x 11 1/8 in. (20.3 x 28.2 cm) L. Latch: 15 1/2 in. (39.3 cm) | The Cloisters Collection, 1955 | Metalwork-Iron 322 | http://www.metmuseum.org/art/collection/search/470148 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
329508 | 329508 | 55.61.1a–f | 0 | 1 | 471579 | The Cloisters 17 | Lock 587 | Lock | European 12 | 15th–16th century | 1400 | 1599 | Iron 13 | Overall (a): 6 3/4 x 7 in. (17.1 x 17.8 cm) Overall (b): 1 3/4 x 9 in. (4.4 x 22.9 cm) Overall (c-f): 2 1/2 in. (6.4 cm) | The Cloisters Collection, 1955 | Metalwork-Iron 322 | http://www.metmuseum.org/art/collection/search/471579 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
329509 | 329509 | 55.61.2a–d | 0 | 1 | 471580 | The Cloisters 17 | Lock 587 | Lock | French 7 | 15th–16th century | 1400 | 1599 | Iron 13 | Overall (a.): 7 1/4 x 6 1/4 in. (18.4 x 15.9 cm) Overall (b, hasp): 11 in. (27.9 cm) Overall (c, d buttress bolts, each,): 6 1/2 in. (16.5 cm) | The Cloisters Collection, 1955 | Metalwork-Iron 322 | http://www.metmuseum.org/art/collection/search/471580 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
329510 | 329510 | 55.61.3a, b | 0 | 1 | 471581 | The Cloisters 17 | Lock 587 | Lock | European 12 | 15th–16th century | 1400 | 1599 | Iron 13 | Overall (a.): 5 1/2 x 4 1/2 in. (14 x 11.4 cm) Overall (b.): 2 3/4 in. (7 cm) | The Cloisters Collection, 1955 | Metalwork-Iron 322 | http://www.metmuseum.org/art/collection/search/471581 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
329511 | 329511 | 55.61.4a, b | 0 | 1 | 471582 | The Cloisters 17 | Lock 587 | Lock | European 12 | 15th–16th century | 1400 | 1599 | Iron 13 | Overall: 4 3/16 x 3 1/2 in. (10.6 x 8.9 cm) | The Cloisters Collection, 1955 | Metalwork-Iron 322 | http://www.metmuseum.org/art/collection/search/471582 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
329512 | 329512 | 55.61.5 | 0 | 1 | 471583 | The Cloisters 17 | Lock 587 | Lock | European 12 | 15th–16th century | 1400 | 1599 | Iron 13 | 7 1/4 × 6 1/4 × 3 in. (18.4 × 15.9 × 7.6 cm) | The Cloisters Collection, 1955 | Metalwork-Iron 322 | http://www.metmuseum.org/art/collection/search/471583 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
329513 | 329513 | 55.61.6a, b | 0 | 1 | 471584 | The Cloisters 17 | Lock 587 | Lock | European 12 | 15th–16th century | 1400 | 1599 | Iron 13 | Overall (a.): 5 1/8 x 3 3/8 in. (13 x 8.6 cm) | The Cloisters Collection, 1955 | Metalwork-Iron 322 | http://www.metmuseum.org/art/collection/search/471584 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
329514 | 329514 | 55.61.8a–d | 0 | 1 | 471585 | The Cloisters 17 | Lock 587 | Lock | French 7 | 15th–16th century | 1400 | 1599 | Iron 13 | Overall (a.): 7 1/2 x 5 1/2 in. (19.1 x 14 cm) Overall (b.): 7 3/8 in. (18.7 cm) Overall (c, d. each,): 7 1/8 in. (18.1 cm) | The Cloisters Collection, 1955 | Metalwork-Iron 322 | http://www.metmuseum.org/art/collection/search/471585 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
329515 | 329515 | 55.61.9a, b | 0 | 1 | 471586 | The Cloisters 17 | Lock 587 | Lock | European or German (?) 6121 | 15th–16th century | 1400 | 1599 | Iron 13 | Overall: 9 to 17-1-4 x 15 1/4 in. (22.9 x 38.7 cm) | The Cloisters Collection, 1955 | Metalwork-Iron 322 | http://www.metmuseum.org/art/collection/search/471586 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
329516 | 329516 | 55.61.10a–e | 0 | 1 | 471587 | The Cloisters 17 | Lock 587 | Lock | European 12 | 15th–16th century | 1400 | 1599 | Iron 13 | Overall (Lock, square): 4 in. (10.2 cm) | The Cloisters Collection, 1955 | Metalwork-Iron 322 | http://www.metmuseum.org/art/collection/search/471587 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
329517 | 329517 | 55.61.11a–c | 0 | 1 | 471588 | The Cloisters 17 | Lock 587 | Lock | European or German (?) 6121 | 15th–16th century | 1400 | 1599 | Iron 13 | Overall: 15 1/8 x 12 7/8 in. (38.4 x 32.7 cm) | The Cloisters Collection, 1955 | Metalwork-Iron 322 | http://www.metmuseum.org/art/collection/search/471588 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
329518 | 329518 | 55.61.12 | 0 | 1 | 471589 | The Cloisters 17 | Lock 587 | Lock | European 12 | 15th–16th century | 1400 | 1599 | Iron 13 | Overall: 6 3/4 x 9 in. (17.1 x 22.9 cm) | The Cloisters Collection, 1955 | Metalwork-Iron 322 | http://www.metmuseum.org/art/collection/search/471589 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
329652 | 329652 | 55.76.2a-f | 0 | 1 | 471724 | The Cloisters 17 | Lock 587 | Lock | French 7 | 15th–16th century | 1400 | 1599 | Iron 13 | Overall: 8 x 9 1/2 x 6 7/8 x 2 7/8 in. (20.3 x 24.1 x 17.5 x 7.3 cm) | The Cloisters Collection, 1955 | Metalwork-Iron 322 | http://www.metmuseum.org/art/collection/search/471724 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
330317 | 330317 | 1999.519.14 | 0 | 1 | 472762 | Medieval Art 6 | Lock 587 | Lock | Byzantine (?) 6092 | 11th century or later | 1000 | 1399 | Cast copper alloy 50452 | Overall: 1 7/16 x 1 7/8 x 9/16 in. (3.6 x 4.8 x 1.4 cm) | Gift of Estate of Lawrence J. Majewski, 1999 | Metalwork-Copper alloy 804 | http://www.metmuseum.org/art/collection/search/472762 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
330318 | 330318 | 1999.519.15 | 0 | 1 | 472763 | Medieval Art 6 | Lock 587 | Lock | Byzantine (?) 6092 | 11th century or later | 1000 | 1399 | Cast copper alloy 50452 | Overall: 1 1/2 x 1 15/16 x 5/16 in. (3.8 x 5 x 0.8 cm) | Gift of Estate of Lawrence J. Majewski, 1999 | Metalwork-Copper alloy 804 | http://www.metmuseum.org/art/collection/search/472763 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
330319 | 330319 | 1999.519.16 | 0 | 1 | 472764 | Medieval Art 6 | Lock 587 | Lock | Byzantine (?) 6092 | 11th century or later | 1000 | 1399 | Cast copper alloy 50452 | Overall: 2 1/16 x 1 15/16 x 1/2 in. (5.2 x 5 x 1.3 cm) | Gift of Estate of Lawrence J. Majewski, 1999 | Metalwork-Copper alloy 804 | http://www.metmuseum.org/art/collection/search/472764 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
331031 | 331031 | 14.1.242 | 0 | 1 | 474918 | Medieval Art 6 | Lock 587 | Lock | Coptic 5992 | 580–640 | 580 | 640 | Wood and rope. 50522 | Overall: 6 7/8 x 3 9/16 x 2 5/8 in. (17.5 x 9 x 6.6 cm) | Rogers Fund, 1914 | Made in 1 | Thebes 1556 | Byzantine Egypt 511 | Woodwork-Miscellany 552 | http://www.metmuseum.org/art/collection/search/474918 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 |
JSON shape: default, array, newline-delimited
CREATE TABLE "MetObjects" ( "Object Number" TEXT, "Is Highlight" INTEGER, "Is Public Domain" INTEGER, "Object ID" INTEGER, "Department" INTEGER, "Object Name" INTEGER, "Title" TEXT, "Culture" INTEGER, "Period" REAL, "Dynasty" INTEGER, "Reign" INTEGER, "Portfolio" INTEGER, "Artist Role" INTEGER, "Artist Prefix" REAL, "Artist Display Name" TEXT, "Artist Display Bio" TEXT, "Artist Suffix" REAL, "Artist Alpha Sort" INTEGER, "Artist Nationality" INTEGER, "Artist Begin Date" TEXT, "Artist End Date" TEXT, "Object Date" TEXT, "Object Begin Date" INTEGER, "Object End Date" INTEGER, "Medium" INTEGER, "Dimensions" TEXT, "Credit Line" TEXT, "Geography Type" INTEGER, "City" INTEGER, "State" INTEGER, "County" INTEGER, "Country" INTEGER, "Region" INTEGER, "Subregion" INTEGER, "Locale" INTEGER, "Locus" INTEGER, "Excavation" INTEGER, "River" INTEGER, "Classification" INTEGER, "Rights and Reproduction" REAL, "Link Resource" TEXT, "Metadata Date" TEXT, "Repository" INTEGER , FOREIGN KEY ("Department") REFERENCES [Department](id), FOREIGN KEY ("Object Name") REFERENCES [Object Name](id), FOREIGN KEY ("Culture") REFERENCES [Culture](id), FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id), FOREIGN KEY ("Reign") REFERENCES [Reign](id), FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id), FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id), FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id), FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id), FOREIGN KEY ("Medium") REFERENCES [Medium](id), FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id), FOREIGN KEY ("City") REFERENCES [City](id), FOREIGN KEY ("State") REFERENCES [State](id), FOREIGN KEY ("County") REFERENCES [County](id), FOREIGN KEY ("Country") REFERENCES [Country](id), FOREIGN KEY ("Region") REFERENCES [Region](id), FOREIGN KEY ("Subregion") REFERENCES [Subregion](id), FOREIGN KEY ("Locale") REFERENCES [Locale](id), FOREIGN KEY ("Locus") REFERENCES [Locus](id), FOREIGN KEY ("Excavation") REFERENCES [Excavation](id), FOREIGN KEY ("River") REFERENCES [River](id), FOREIGN KEY ("Classification") REFERENCES [Classification](id), FOREIGN KEY ("Repository") REFERENCES [Repository](id)); CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department"); CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name"); CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture"); CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty"); CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign"); CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio"); CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role"); CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort"); CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality"); CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium"); CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type"); CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City"); CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State"); CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County"); CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country"); CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region"); CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion"); CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale"); CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus"); CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation"); CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River"); CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification"); CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository"); CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight"); CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain"); CREATE INDEX metobjects_Department ON MetObjects("Department"); CREATE INDEX metobjects_Culture ON MetObjects("Culture"); CREATE INDEX metobjects_Period ON MetObjects("Period"); CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty"); CREATE INDEX metobjects_Medium ON MetObjects("Medium"); CREATE INDEX metobjects_City ON MetObjects("City"); CREATE INDEX metobjects_State ON MetObjects("State"); CREATE INDEX metobjects_County ON MetObjects("County"); CREATE INDEX metobjects_Country ON MetObjects("Country"); CREATE INDEX metobjects_Region ON MetObjects("Region"); CREATE INDEX metobjects_Subregion ON MetObjects("Subregion"); CREATE INDEX metobjects_Locale ON MetObjects("Locale"); CREATE INDEX metobjects_Locus ON MetObjects("Locus"); CREATE INDEX metobjects_Excavation ON MetObjects("Excavation"); CREATE INDEX metobjects_River ON MetObjects("River");